{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "088b8a79",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "      <th>tender_complete_ip</th>\n",
       "      <th>mac_address</th>\n",
       "      <th>hard_disk_seq</th>\n",
       "      <th>status</th>\n",
       "      <th>create_time</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>project_id</th>\n",
       "      <th>bidder</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">7AF0FF9F9C244A679BB07B5CF63AA1D8</th>\n",
       "      <th>闪购软件公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>777777.77</td>\n",
       "      <td>1个月内</td>\n",
       "      <td>绝云椒椒</td>\n",
       "      <td>个</td>\n",
       "      <td>7777.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/8/2021 16:22:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳市华为技术有限公司7777</th>\n",
       "      <td>货物</td>\n",
       "      <td>888888.88</td>\n",
       "      <td>1周内</td>\n",
       "      <td>马尾草</td>\n",
       "      <td>柱</td>\n",
       "      <td>888.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/8/2021 16:23:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>珠海格力电器股份有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>955555.55</td>\n",
       "      <td>半年内</td>\n",
       "      <td>绯樱球</td>\n",
       "      <td>包</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/8/2021 16:23:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">03883E99BA7446BDA6622B5DC496A85D</th>\n",
       "      <th>闪购软件公司</th>\n",
       "      <td>工程</td>\n",
       "      <td>876543.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>15/8/2021 11:33:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳市国采软件公司</th>\n",
       "      <td>工程</td>\n",
       "      <td>998765.43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>15/8/2021 12:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">A38C772C3A1E43E880F66721A2359243</th>\n",
       "      <th>云智谷物联网技术（深圳）有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>1202235.00</td>\n",
       "      <td>30</td>\n",
       "      <td>消防员灭火防护服</td>\n",
       "      <td>ZFMH-KTZ A</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>10/8/2023 09:35:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州道熙建材有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>879329.00</td>\n",
       "      <td>自合同签订之日起30日内完成交货</td>\n",
       "      <td>桂安牌手提式干粉灭火器1 开隆牌消防员灭火服</td>\n",
       "      <td>MFTZ/ABC 4 、ZFMH-KL B</td>\n",
       "      <td>2165.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>10/8/2023 09:43:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">10895A88C81C4FD0923CD515E90C66F5</th>\n",
       "      <th>广东知青搬家集团有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1798000.00</td>\n",
       "      <td>成交供应商在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18/8/2023 09:35:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州欧玮仪器技术有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1799100.00</td>\n",
       "      <td>在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原因、学院要...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18/8/2023 09:36:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州仪速安电子科技有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1797950.00</td>\n",
       "      <td>仪速安科技承诺在采购人发出搬迁通知启动搬迁工作后，25天内完成搬迁、安装及调试。特殊情况如场...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18/8/2023 09:36:35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8314 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  purchase_project_type_mean  \\\n",
       "project_id                       bidder                                        \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                                   货物   \n",
       "                                 深圳市华为技术有限公司7777                          货物   \n",
       "                                 珠海格力电器股份有限公司                             货物   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                                   工程   \n",
       "                                 深圳市国采软件公司                                工程   \n",
       "...                                                                      ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司                         货物   \n",
       "                                 广州道熙建材有限公司                               货物   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司                             服务   \n",
       "                                 广州欧玮仪器技术有限公司                             服务   \n",
       "                                 广州仪速安电子科技有限公司                            服务   \n",
       "\n",
       "                                                    bid_price  \\\n",
       "project_id                       bidder                         \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司             777777.77   \n",
       "                                 深圳市华为技术有限公司7777    888888.88   \n",
       "                                 珠海格力电器股份有限公司       955555.55   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司             876543.21   \n",
       "                                 深圳市国采软件公司          998765.43   \n",
       "...                                                       ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司  1202235.00   \n",
       "                                 广州道熙建材有限公司         879329.00   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司      1798000.00   \n",
       "                                 广州欧玮仪器技术有限公司      1799100.00   \n",
       "                                 广州仪速安电子科技有限公司     1797950.00   \n",
       "\n",
       "                                                                                       delivery_time  \\\n",
       "project_id                       bidder                                                                \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                                                         1个月内   \n",
       "                                 深圳市华为技术有限公司7777                                                 1周内   \n",
       "                                 珠海格力电器股份有限公司                                                    半年内   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                                                          NaN   \n",
       "                                 深圳市国采软件公司                                                       NaN   \n",
       "...                                                                                              ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司                                                 30   \n",
       "                                 广州道熙建材有限公司                                         自合同签订之日起30日内完成交货   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司      成交供应商在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原...   \n",
       "                                 广州欧玮仪器技术有限公司      在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原因、学院要...   \n",
       "                                 广州仪速安电子科技有限公司     仪速安科技承诺在采购人发出搬迁通知启动搬迁工作后，25天内完成搬迁、安装及调试。特殊情况如场...   \n",
       "\n",
       "                                                                     name  \\\n",
       "project_id                       bidder                                     \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                              绝云椒椒   \n",
       "                                 深圳市华为技术有限公司7777                      马尾草   \n",
       "                                 珠海格力电器股份有限公司                         绯樱球   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                               NaN   \n",
       "                                 深圳市国采软件公司                            NaN   \n",
       "...                                                                   ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司                消防员灭火防护服   \n",
       "                                 广州道熙建材有限公司        桂安牌手提式干粉灭火器1 开隆牌消防员灭火服   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司                         NaN   \n",
       "                                 广州欧玮仪器技术有限公司                         NaN   \n",
       "                                 广州仪速安电子科技有限公司                        NaN   \n",
       "\n",
       "                                                                bid_spec  \\\n",
       "project_id                       bidder                                    \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                                个   \n",
       "                                 深圳市华为技术有限公司7777                       柱   \n",
       "                                 珠海格力电器股份有限公司                          包   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                              NaN   \n",
       "                                 深圳市国采软件公司                           NaN   \n",
       "...                                                                  ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司             ZFMH-KTZ A   \n",
       "                                 广州道熙建材有限公司        MFTZ/ABC 4 、ZFMH-KL B   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司                        NaN   \n",
       "                                 广州欧玮仪器技术有限公司                        NaN   \n",
       "                                 广州仪速安电子科技有限公司                       NaN   \n",
       "\n",
       "                                                   bid_amount  \\\n",
       "project_id                       bidder                         \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                7777.0   \n",
       "                                 深圳市华为技术有限公司7777        888.0   \n",
       "                                 珠海格力电器股份有限公司          1999.0   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                   NaN   \n",
       "                                 深圳市国采软件公司                NaN   \n",
       "...                                                       ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司        15.0   \n",
       "                                 广州道熙建材有限公司            2165.0   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司             NaN   \n",
       "                                 广州欧玮仪器技术有限公司             NaN   \n",
       "                                 广州仪速安电子科技有限公司            NaN   \n",
       "\n",
       "                                                   tender_complete_ip  \\\n",
       "project_id                       bidder                                 \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                           NaN   \n",
       "                                 深圳市华为技术有限公司7777                  NaN   \n",
       "                                 珠海格力电器股份有限公司                     NaN   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                           NaN   \n",
       "                                 深圳市国采软件公司                        NaN   \n",
       "...                                                               ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司                 NaN   \n",
       "                                 广州道熙建材有限公司                       NaN   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司                     NaN   \n",
       "                                 广州欧玮仪器技术有限公司                     NaN   \n",
       "                                 广州仪速安电子科技有限公司                    NaN   \n",
       "\n",
       "                                                   mac_address  hard_disk_seq  \\\n",
       "project_id                       bidder                                         \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                    NaN            NaN   \n",
       "                                 深圳市华为技术有限公司7777           NaN            NaN   \n",
       "                                 珠海格力电器股份有限公司              NaN            NaN   \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                    NaN            NaN   \n",
       "                                 深圳市国采软件公司                 NaN            NaN   \n",
       "...                                                        ...            ...   \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司          NaN            NaN   \n",
       "                                 广州道熙建材有限公司                NaN            NaN   \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司              NaN            NaN   \n",
       "                                 广州欧玮仪器技术有限公司              NaN            NaN   \n",
       "                                 广州仪速安电子科技有限公司             NaN            NaN   \n",
       "\n",
       "                                                   status         create_time  \n",
       "project_id                       bidder                                        \n",
       "7AF0FF9F9C244A679BB07B5CF63AA1D8 闪购软件公司                 1  12/8/2021 16:22:19  \n",
       "                                 深圳市华为技术有限公司7777        1  12/8/2021 16:23:11  \n",
       "                                 珠海格力电器股份有限公司           1  12/8/2021 16:23:51  \n",
       "03883E99BA7446BDA6622B5DC496A85D 闪购软件公司                 1  15/8/2021 11:33:04  \n",
       "                                 深圳市国采软件公司              1  15/8/2021 12:46:19  \n",
       "...                                                   ...                 ...  \n",
       "A38C772C3A1E43E880F66721A2359243 云智谷物联网技术（深圳）有限公司       1  10/8/2023 09:35:34  \n",
       "                                 广州道熙建材有限公司             1  10/8/2023 09:43:18  \n",
       "10895A88C81C4FD0923CD515E90C66F5 广东知青搬家集团有限公司           1  18/8/2023 09:35:58  \n",
       "                                 广州欧玮仪器技术有限公司           1  18/8/2023 09:36:05  \n",
       "                                 广州仪速安电子科技有限公司          1  18/8/2023 09:36:35  \n",
       "\n",
       "[8314 rows x 11 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from pylab import mpl\n",
    "mpl.rcParams[\"font.sans-serif\"] = [\"SimHei\"]\n",
    "mpl.rcParams[\"axes.unicode_minus\"] = False\n",
    "\n",
    "csvData = pd.read_csv('d:/data/tdz_opening_bid_report.csv')\n",
    "csvData=csvData.drop(['id','source_id','bid_section_id','bid_section_code','dark_code','bid_section_code_mean','purchase_section_id','purchase_project_type','supply_id','bid_security','bid_security_time','note','signatrue_id','bid_price_chn','origin','bid_apply_json','status_mean','modify_time'],axis=1)\n",
    "csvData.set_index(['project_id','bidder'])\n",
    "# csvData.set_index(['bidder'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "7a4b47c0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'工程'"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#取值采用 【先列后行】 data[列名][行名]\n",
    "csvData['purchase_project_type_mean'][1950]\n",
    "\n",
    "# iloc [:行数,:列数] eg csvData.iloc[:5,:7]\n",
    "# csvData.iloc[:5,]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "b36ecb2e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bidder</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8000</th>\n",
       "      <td>广东晟强建设工程有限公司</td>\n",
       "      <td>2211615.19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8001</th>\n",
       "      <td>广东骏天建设工程有限公司</td>\n",
       "      <td>2219466.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8002</th>\n",
       "      <td>广东建中建设有限公司</td>\n",
       "      <td>2139386.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8003</th>\n",
       "      <td>广东展华建设工程有限公司</td>\n",
       "      <td>2131535.41</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8004</th>\n",
       "      <td>广东裕兆丰建设有限公司</td>\n",
       "      <td>2182566.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8309</th>\n",
       "      <td>云智谷物联网技术（深圳）有限公司</td>\n",
       "      <td>1202235.00</td>\n",
       "      <td>30</td>\n",
       "      <td>消防员灭火防护服</td>\n",
       "      <td>ZFMH-KTZ A</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8310</th>\n",
       "      <td>广州道熙建材有限公司</td>\n",
       "      <td>879329.00</td>\n",
       "      <td>自合同签订之日起30日内完成交货</td>\n",
       "      <td>桂安牌手提式干粉灭火器1 开隆牌消防员灭火服</td>\n",
       "      <td>MFTZ/ABC 4 、ZFMH-KL B</td>\n",
       "      <td>2165.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8311</th>\n",
       "      <td>广东知青搬家集团有限公司</td>\n",
       "      <td>1798000.00</td>\n",
       "      <td>成交供应商在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8312</th>\n",
       "      <td>广州欧玮仪器技术有限公司</td>\n",
       "      <td>1799100.00</td>\n",
       "      <td>在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原因、学院要...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8313</th>\n",
       "      <td>广州仪速安电子科技有限公司</td>\n",
       "      <td>1797950.00</td>\n",
       "      <td>仪速安科技承诺在采购人发出搬迁通知启动搬迁工作后，25天内完成搬迁、安装及调试。特殊情况如场...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>314 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                bidder   bid_price  \\\n",
       "8000      广东晟强建设工程有限公司  2211615.19   \n",
       "8001      广东骏天建设工程有限公司  2219466.14   \n",
       "8002        广东建中建设有限公司  2139386.37   \n",
       "8003      广东展华建设工程有限公司  2131535.41   \n",
       "8004       广东裕兆丰建设有限公司  2182566.66   \n",
       "...                ...         ...   \n",
       "8309  云智谷物联网技术（深圳）有限公司  1202235.00   \n",
       "8310        广州道熙建材有限公司   879329.00   \n",
       "8311      广东知青搬家集团有限公司  1798000.00   \n",
       "8312      广州欧玮仪器技术有限公司  1799100.00   \n",
       "8313     广州仪速安电子科技有限公司  1797950.00   \n",
       "\n",
       "                                          delivery_time  \\\n",
       "8000                                                NaN   \n",
       "8001                                                NaN   \n",
       "8002                                                NaN   \n",
       "8003                                                NaN   \n",
       "8004                                                NaN   \n",
       "...                                                 ...   \n",
       "8309                                                 30   \n",
       "8310                                   自合同签订之日起30日内完成交货   \n",
       "8311  成交供应商在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原...   \n",
       "8312  在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原因、学院要...   \n",
       "8313  仪速安科技承诺在采购人发出搬迁通知启动搬迁工作后，25天内完成搬迁、安装及调试。特殊情况如场...   \n",
       "\n",
       "                        name               bid_spec  bid_amount  \n",
       "8000                     NaN                    NaN         NaN  \n",
       "8001                     NaN                    NaN         NaN  \n",
       "8002                     NaN                    NaN         NaN  \n",
       "8003                     NaN                    NaN         NaN  \n",
       "8004                     NaN                    NaN         NaN  \n",
       "...                      ...                    ...         ...  \n",
       "8309                消防员灭火防护服             ZFMH-KTZ A        15.0  \n",
       "8310  桂安牌手提式干粉灭火器1 开隆牌消防员灭火服  MFTZ/ABC 4 、ZFMH-KL B      2165.0  \n",
       "8311                     NaN                    NaN         NaN  \n",
       "8312                     NaN                    NaN         NaN  \n",
       "8313                     NaN                    NaN         NaN  \n",
       "\n",
       "[314 rows x 6 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loc 【先行后列】\n",
    "csvData.loc[8000:8314,'bidder':'bid_amount']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "495d9c94",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bidder</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>bid_amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8000</th>\n",
       "      <td>广东晟强建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2211615.19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8001</th>\n",
       "      <td>广东骏天建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2219466.14</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8002</th>\n",
       "      <td>广东建中建设有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2139386.37</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8003</th>\n",
       "      <td>广东展华建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2131535.41</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8004</th>\n",
       "      <td>广东裕兆丰建设有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2182566.66</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8309</th>\n",
       "      <td>云智谷物联网技术（深圳）有限公司</td>\n",
       "      <td>货物</td>\n",
       "      <td>1202235.00</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8310</th>\n",
       "      <td>广州道熙建材有限公司</td>\n",
       "      <td>货物</td>\n",
       "      <td>879329.00</td>\n",
       "      <td>2165.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8311</th>\n",
       "      <td>广东知青搬家集团有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>1798000.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8312</th>\n",
       "      <td>广州欧玮仪器技术有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>1799100.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8313</th>\n",
       "      <td>广州仪速安电子科技有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>1797950.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>314 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                bidder purchase_project_type_mean   bid_price  bid_amount\n",
       "8000      广东晟强建设工程有限公司                         工程  2211615.19         NaN\n",
       "8001      广东骏天建设工程有限公司                         工程  2219466.14         NaN\n",
       "8002        广东建中建设有限公司                         工程  2139386.37         NaN\n",
       "8003      广东展华建设工程有限公司                         工程  2131535.41         NaN\n",
       "8004       广东裕兆丰建设有限公司                         工程  2182566.66         NaN\n",
       "...                ...                        ...         ...         ...\n",
       "8309  云智谷物联网技术（深圳）有限公司                         货物  1202235.00        15.0\n",
       "8310        广州道熙建材有限公司                         货物   879329.00      2165.0\n",
       "8311      广东知青搬家集团有限公司                         服务  1798000.00         NaN\n",
       "8312      广州欧玮仪器技术有限公司                         服务  1799100.00         NaN\n",
       "8313     广州仪速安电子科技有限公司                         服务  1797950.00         NaN\n",
       "\n",
       "[314 rows x 4 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 推荐使用 loc 和 iloc 方法\n",
    "csvData.loc[csvData.index[8000:8314],['bidder','purchase_project_type_mean','bid_price','bid_amount']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "308d4403",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bidder</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>bid_amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8000</th>\n",
       "      <td>广东晟强建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2211615.19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8001</th>\n",
       "      <td>广东骏天建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2219466.14</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8002</th>\n",
       "      <td>广东建中建设有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2139386.37</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8003</th>\n",
       "      <td>广东展华建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2131535.41</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8004</th>\n",
       "      <td>广东裕兆丰建设有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2182566.66</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8309</th>\n",
       "      <td>云智谷物联网技术（深圳）有限公司</td>\n",
       "      <td>货物</td>\n",
       "      <td>1202235.00</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8310</th>\n",
       "      <td>广州道熙建材有限公司</td>\n",
       "      <td>货物</td>\n",
       "      <td>879329.00</td>\n",
       "      <td>2165.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8311</th>\n",
       "      <td>广东知青搬家集团有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>1798000.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8312</th>\n",
       "      <td>广州欧玮仪器技术有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>1799100.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8313</th>\n",
       "      <td>广州仪速安电子科技有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>1797950.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>314 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                bidder purchase_project_type_mean   bid_price  bid_amount\n",
       "8000      广东晟强建设工程有限公司                         工程  2211615.19         NaN\n",
       "8001      广东骏天建设工程有限公司                         工程  2219466.14         NaN\n",
       "8002        广东建中建设有限公司                         工程  2139386.37         NaN\n",
       "8003      广东展华建设工程有限公司                         工程  2131535.41         NaN\n",
       "8004       广东裕兆丰建设有限公司                         工程  2182566.66         NaN\n",
       "...                ...                        ...         ...         ...\n",
       "8309  云智谷物联网技术（深圳）有限公司                         货物  1202235.00        15.0\n",
       "8310        广州道熙建材有限公司                         货物   879329.00      2165.0\n",
       "8311      广东知青搬家集团有限公司                         服务  1798000.00         NaN\n",
       "8312      广州欧玮仪器技术有限公司                         服务  1799100.00         NaN\n",
       "8313     广州仪速安电子科技有限公司                         服务  1797950.00         NaN\n",
       "\n",
       "[314 rows x 4 columns]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 推荐使用 loc 和 iloc 方法\n",
    "csvData.iloc[8000:8314,csvData.columns.get_indexer(['bidder','purchase_project_type_mean','bid_price','bid_amount'])]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "809fca11",
   "metadata": {},
   "source": [
    "# 以后就用 loc 方法"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "8513363e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bidder</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>bid_amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7000</th>\n",
       "      <td>广州时泰建设工程有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>12.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7001</th>\n",
       "      <td>深圳市欣和建设工程有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>8.30</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7002</th>\n",
       "      <td>广州茂达建筑工程有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>92.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7003</th>\n",
       "      <td>协安建设（广东）有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>10.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7004</th>\n",
       "      <td>广东中钦建设集团有限公司</td>\n",
       "      <td>服务</td>\n",
       "      <td>10.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7495</th>\n",
       "      <td>广东骏森建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2385724.12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7496</th>\n",
       "      <td>广东龙元建设有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>1997231.52</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7497</th>\n",
       "      <td>广东兴煌建设工程有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>1981739.82</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7498</th>\n",
       "      <td>众盛（广东）建设有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>2036119.38</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7499</th>\n",
       "      <td>广东中余建设集团有限公司</td>\n",
       "      <td>工程</td>\n",
       "      <td>1985485.56</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             bidder purchase_project_type_mean   bid_price  bid_amount\n",
       "7000   广州时泰建设工程有限公司                         服务       12.00         NaN\n",
       "7001  深圳市欣和建设工程有限公司                         服务        8.30         NaN\n",
       "7002   广州茂达建筑工程有限公司                         服务       92.00         NaN\n",
       "7003   协安建设（广东）有限公司                         服务       10.00         NaN\n",
       "7004   广东中钦建设集团有限公司                         服务       10.00         NaN\n",
       "...             ...                        ...         ...         ...\n",
       "7495   广东骏森建设工程有限公司                         工程  2385724.12         NaN\n",
       "7496     广东龙元建设有限公司                         工程  1997231.52         NaN\n",
       "7497   广东兴煌建设工程有限公司                         工程  1981739.82         NaN\n",
       "7498   众盛（广东）建设有限公司                         工程  2036119.38         NaN\n",
       "7499   广东中余建设集团有限公司                         工程  1985485.56         NaN\n",
       "\n",
       "[500 rows x 4 columns]"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csvData.loc[csvData.index[7000:7500],['bidder','purchase_project_type_mean','bid_price','bid_amount']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "9071ae06",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Administrator\\AppData\\Local\\Temp\\ipykernel_14272\\2037800000.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  csvData['purchase_project_type_mean'][1]='货物1'\n"
     ]
    }
   ],
   "source": [
    "# 修改值 但是没被保存到原文件\n",
    "csvData['purchase_project_type_mean'][1]='货物1'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "5e50903d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>project_id</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bidder</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "      <th>tender_complete_ip</th>\n",
       "      <th>mac_address</th>\n",
       "      <th>hard_disk_seq</th>\n",
       "      <th>status</th>\n",
       "      <th>create_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4335</th>\n",
       "      <td>D1A8055B3DA8492D9FE446E72D2877A4</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州市优尚家具有限公司</td>\n",
       "      <td>1246673.0</td>\n",
       "      <td>合同签订后 30 天 内交货并完成安装</td>\n",
       "      <td>品牌：优尚、名称：双面科学实验台</td>\n",
       "      <td>YS-011、1400mm*1400mm* 750mm</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9/9/2022 14:37:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4334</th>\n",
       "      <td>D1A8055B3DA8492D9FE446E72D2877A4</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州市鼎昱实验室系统工程有限公司</td>\n",
       "      <td>1248950.0</td>\n",
       "      <td>30</td>\n",
       "      <td>双面科学实验台</td>\n",
       "      <td>1400mm*1400mm*750mm</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9/9/2022 14:34:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4333</th>\n",
       "      <td>D1A8055B3DA8492D9FE446E72D2877A4</td>\n",
       "      <td>货物</td>\n",
       "      <td>广东星林家具有限公司</td>\n",
       "      <td>1239078.0</td>\n",
       "      <td>25天</td>\n",
       "      <td>星林源</td>\n",
       "      <td>详见投标明细报价表</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9/9/2022 14:34:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4332</th>\n",
       "      <td>CCB785E36C9246D59E582CD6A5CDA3B9</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州卓艺建筑科技有限公司</td>\n",
       "      <td>4021600.0</td>\n",
       "      <td>30个日历天</td>\n",
       "      <td>卓艺</td>\n",
       "      <td>ZY0901</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9/9/2022 09:33:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4331</th>\n",
       "      <td>CCB785E36C9246D59E582CD6A5CDA3B9</td>\n",
       "      <td>货物</td>\n",
       "      <td>上海史密斯品牌管理有限公司</td>\n",
       "      <td>3994000.0</td>\n",
       "      <td>30</td>\n",
       "      <td>史密斯</td>\n",
       "      <td>AE2201，AE2202，AE2203，AE2204，AE2205</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9/9/2022 09:33:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4596</th>\n",
       "      <td>4063957EDA5548B6B71B5A67E52B5976</td>\n",
       "      <td>货物</td>\n",
       "      <td>北京华晟嘉业环境科技有限公司</td>\n",
       "      <td>678000.0</td>\n",
       "      <td>90</td>\n",
       "      <td>麦克维尔/西门子/威乐/NGI</td>\n",
       "      <td>详见配置清单</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/11/2022 09:40:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4595</th>\n",
       "      <td>4063957EDA5548B6B71B5A67E52B5976</td>\n",
       "      <td>货物</td>\n",
       "      <td>航天朗赛科技（北京）有限责任公司</td>\n",
       "      <td>675000.0</td>\n",
       "      <td>60天</td>\n",
       "      <td>大金、约克、江森自控、日置、格兰富、艾德克斯、西门子</td>\n",
       "      <td>详见配置清单</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/11/2022 09:40:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4594</th>\n",
       "      <td>4063957EDA5548B6B71B5A67E52B5976</td>\n",
       "      <td>货物</td>\n",
       "      <td>广东蓝天智通科技有限公司</td>\n",
       "      <td>1966252.0</td>\n",
       "      <td>按招标文件或合同明确指定的时间内交货</td>\n",
       "      <td>橙智孝云</td>\n",
       "      <td>定制</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/11/2022 09:39:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4593</th>\n",
       "      <td>4063957EDA5548B6B71B5A67E52B5976</td>\n",
       "      <td>货物</td>\n",
       "      <td>智慧校园（广东）教育科技有限公司</td>\n",
       "      <td>1975230.0</td>\n",
       "      <td>按招标文件或合同明确指定时间内交货。</td>\n",
       "      <td>智慧家居系统</td>\n",
       "      <td>定制</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/11/2022 09:39:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4592</th>\n",
       "      <td>4063957EDA5548B6B71B5A67E52B5976</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州银康数字科技有限公司</td>\n",
       "      <td>1959900.0</td>\n",
       "      <td>按合同中指定的交货时间内交货</td>\n",
       "      <td>智慧家居系统</td>\n",
       "      <td>定制</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/11/2022 09:39:38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8314 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            project_id purchase_project_type_mean  \\\n",
       "4335  D1A8055B3DA8492D9FE446E72D2877A4                         货物   \n",
       "4334  D1A8055B3DA8492D9FE446E72D2877A4                         货物   \n",
       "4333  D1A8055B3DA8492D9FE446E72D2877A4                         货物   \n",
       "4332  CCB785E36C9246D59E582CD6A5CDA3B9                         货物   \n",
       "4331  CCB785E36C9246D59E582CD6A5CDA3B9                         货物   \n",
       "...                                ...                        ...   \n",
       "4596  4063957EDA5548B6B71B5A67E52B5976                         货物   \n",
       "4595  4063957EDA5548B6B71B5A67E52B5976                         货物   \n",
       "4594  4063957EDA5548B6B71B5A67E52B5976                         货物   \n",
       "4593  4063957EDA5548B6B71B5A67E52B5976                         货物   \n",
       "4592  4063957EDA5548B6B71B5A67E52B5976                         货物   \n",
       "\n",
       "                bidder  bid_price        delivery_time  \\\n",
       "4335       广州市优尚家具有限公司  1246673.0  合同签订后 30 天 内交货并完成安装   \n",
       "4334  广州市鼎昱实验室系统工程有限公司  1248950.0                   30   \n",
       "4333        广东星林家具有限公司  1239078.0                  25天   \n",
       "4332      广州卓艺建筑科技有限公司  4021600.0               30个日历天   \n",
       "4331     上海史密斯品牌管理有限公司  3994000.0                   30   \n",
       "...                ...        ...                  ...   \n",
       "4596    北京华晟嘉业环境科技有限公司   678000.0                   90   \n",
       "4595  航天朗赛科技（北京）有限责任公司   675000.0                  60天   \n",
       "4594      广东蓝天智通科技有限公司  1966252.0   按招标文件或合同明确指定的时间内交货   \n",
       "4593  智慧校园（广东）教育科技有限公司  1975230.0   按招标文件或合同明确指定时间内交货。   \n",
       "4592      广州银康数字科技有限公司  1959900.0       按合同中指定的交货时间内交货   \n",
       "\n",
       "                            name                            bid_spec  \\\n",
       "4335            品牌：优尚、名称：双面科学实验台         YS-011、1400mm*1400mm* 750mm   \n",
       "4334                     双面科学实验台                 1400mm*1400mm*750mm   \n",
       "4333                         星林源                           详见投标明细报价表   \n",
       "4332                          卓艺                              ZY0901   \n",
       "4331                         史密斯  AE2201，AE2202，AE2203，AE2204，AE2205   \n",
       "...                          ...                                 ...   \n",
       "4596             麦克维尔/西门子/威乐/NGI                              详见配置清单   \n",
       "4595  大金、约克、江森自控、日置、格兰富、艾德克斯、西门子                              详见配置清单   \n",
       "4594                        橙智孝云                                  定制   \n",
       "4593                      智慧家居系统                                  定制   \n",
       "4592                      智慧家居系统                                  定制   \n",
       "\n",
       "      bid_amount  tender_complete_ip  mac_address  hard_disk_seq  status  \\\n",
       "4335        58.0                 NaN          NaN            NaN       1   \n",
       "4334        58.0                 NaN          NaN            NaN       1   \n",
       "4333         1.0                 NaN          NaN            NaN       1   \n",
       "4332        13.0                 NaN          NaN            NaN       1   \n",
       "4331        13.0                 NaN          NaN            NaN       1   \n",
       "...          ...                 ...          ...            ...     ...   \n",
       "4596         5.0                 NaN          NaN            NaN       1   \n",
       "4595         5.0                 NaN          NaN            NaN       1   \n",
       "4594         1.0                 NaN          NaN            NaN       1   \n",
       "4593         1.0                 NaN          NaN            NaN       1   \n",
       "4592         1.0                 NaN          NaN            NaN       1   \n",
       "\n",
       "             create_time  \n",
       "4335   9/9/2022 14:37:01  \n",
       "4334   9/9/2022 14:34:19  \n",
       "4333   9/9/2022 14:34:18  \n",
       "4332   9/9/2022 09:33:07  \n",
       "4331   9/9/2022 09:33:07  \n",
       "...                  ...  \n",
       "4596  1/11/2022 09:40:20  \n",
       "4595  1/11/2022 09:40:00  \n",
       "4594  1/11/2022 09:39:46  \n",
       "4593  1/11/2022 09:39:42  \n",
       "4592  1/11/2022 09:39:38  \n",
       "\n",
       "[8314 rows x 13 columns]"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 排序，默认True升序\n",
    "csvData.sort_values(by=['create_time'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "89697659",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>project_id</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bidder</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "      <th>tender_complete_ip</th>\n",
       "      <th>mac_address</th>\n",
       "      <th>hard_disk_seq</th>\n",
       "      <th>status</th>\n",
       "      <th>create_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8313</th>\n",
       "      <td>10895A88C81C4FD0923CD515E90C66F5</td>\n",
       "      <td>服务</td>\n",
       "      <td>广州仪速安电子科技有限公司</td>\n",
       "      <td>1797950.00</td>\n",
       "      <td>仪速安科技承诺在采购人发出搬迁通知启动搬迁工作后，25天内完成搬迁、安装及调试。特殊情况如场...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18/8/2023 09:36:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8312</th>\n",
       "      <td>10895A88C81C4FD0923CD515E90C66F5</td>\n",
       "      <td>服务</td>\n",
       "      <td>广州欧玮仪器技术有限公司</td>\n",
       "      <td>1799100.00</td>\n",
       "      <td>在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原因、学院要...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18/8/2023 09:36:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8311</th>\n",
       "      <td>10895A88C81C4FD0923CD515E90C66F5</td>\n",
       "      <td>服务</td>\n",
       "      <td>广东知青搬家集团有限公司</td>\n",
       "      <td>1798000.00</td>\n",
       "      <td>成交供应商在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18/8/2023 09:35:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8310</th>\n",
       "      <td>A38C772C3A1E43E880F66721A2359243</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州道熙建材有限公司</td>\n",
       "      <td>879329.00</td>\n",
       "      <td>自合同签订之日起30日内完成交货</td>\n",
       "      <td>桂安牌手提式干粉灭火器1 开隆牌消防员灭火服</td>\n",
       "      <td>MFTZ/ABC 4 、ZFMH-KL B</td>\n",
       "      <td>2165.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>10/8/2023 09:43:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8309</th>\n",
       "      <td>A38C772C3A1E43E880F66721A2359243</td>\n",
       "      <td>货物</td>\n",
       "      <td>云智谷物联网技术（深圳）有限公司</td>\n",
       "      <td>1202235.00</td>\n",
       "      <td>30</td>\n",
       "      <td>消防员灭火防护服</td>\n",
       "      <td>ZFMH-KTZ A</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>10/8/2023 09:35:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>03883E99BA7446BDA6622B5DC496A85D</td>\n",
       "      <td>工程</td>\n",
       "      <td>深圳市国采软件公司</td>\n",
       "      <td>998765.43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>15/8/2021 12:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>03883E99BA7446BDA6622B5DC496A85D</td>\n",
       "      <td>工程</td>\n",
       "      <td>闪购软件公司</td>\n",
       "      <td>876543.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>15/8/2021 11:33:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7AF0FF9F9C244A679BB07B5CF63AA1D8</td>\n",
       "      <td>货物</td>\n",
       "      <td>珠海格力电器股份有限公司</td>\n",
       "      <td>955555.55</td>\n",
       "      <td>半年内</td>\n",
       "      <td>绯樱球</td>\n",
       "      <td>包</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/8/2021 16:23:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7AF0FF9F9C244A679BB07B5CF63AA1D8</td>\n",
       "      <td>货物1</td>\n",
       "      <td>深圳市华为技术有限公司7777</td>\n",
       "      <td>888888.88</td>\n",
       "      <td>1周内</td>\n",
       "      <td>马尾草</td>\n",
       "      <td>柱</td>\n",
       "      <td>888.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/8/2021 16:23:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7AF0FF9F9C244A679BB07B5CF63AA1D8</td>\n",
       "      <td>货物</td>\n",
       "      <td>闪购软件公司</td>\n",
       "      <td>777777.77</td>\n",
       "      <td>1个月内</td>\n",
       "      <td>绝云椒椒</td>\n",
       "      <td>个</td>\n",
       "      <td>7777.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/8/2021 16:22:19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8314 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            project_id purchase_project_type_mean  \\\n",
       "8313  10895A88C81C4FD0923CD515E90C66F5                         服务   \n",
       "8312  10895A88C81C4FD0923CD515E90C66F5                         服务   \n",
       "8311  10895A88C81C4FD0923CD515E90C66F5                         服务   \n",
       "8310  A38C772C3A1E43E880F66721A2359243                         货物   \n",
       "8309  A38C772C3A1E43E880F66721A2359243                         货物   \n",
       "...                                ...                        ...   \n",
       "4     03883E99BA7446BDA6622B5DC496A85D                         工程   \n",
       "3     03883E99BA7446BDA6622B5DC496A85D                         工程   \n",
       "2     7AF0FF9F9C244A679BB07B5CF63AA1D8                         货物   \n",
       "1     7AF0FF9F9C244A679BB07B5CF63AA1D8                        货物1   \n",
       "0     7AF0FF9F9C244A679BB07B5CF63AA1D8                         货物   \n",
       "\n",
       "                bidder   bid_price  \\\n",
       "8313     广州仪速安电子科技有限公司  1797950.00   \n",
       "8312      广州欧玮仪器技术有限公司  1799100.00   \n",
       "8311      广东知青搬家集团有限公司  1798000.00   \n",
       "8310        广州道熙建材有限公司   879329.00   \n",
       "8309  云智谷物联网技术（深圳）有限公司  1202235.00   \n",
       "...                ...         ...   \n",
       "4            深圳市国采软件公司   998765.43   \n",
       "3               闪购软件公司   876543.21   \n",
       "2         珠海格力电器股份有限公司   955555.55   \n",
       "1      深圳市华为技术有限公司7777   888888.88   \n",
       "0               闪购软件公司   777777.77   \n",
       "\n",
       "                                          delivery_time  \\\n",
       "8313  仪速安科技承诺在采购人发出搬迁通知启动搬迁工作后，25天内完成搬迁、安装及调试。特殊情况如场...   \n",
       "8312  在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原因、学院要...   \n",
       "8311  成交供应商在采购人发出搬迁通知启动搬迁工作后，30天内完成搬迁、安装及调试。特殊情况如场地原...   \n",
       "8310                                   自合同签订之日起30日内完成交货   \n",
       "8309                                                 30   \n",
       "...                                                 ...   \n",
       "4                                                   NaN   \n",
       "3                                                   NaN   \n",
       "2                                                   半年内   \n",
       "1                                                   1周内   \n",
       "0                                                  1个月内   \n",
       "\n",
       "                        name               bid_spec  bid_amount  \\\n",
       "8313                     NaN                    NaN         NaN   \n",
       "8312                     NaN                    NaN         NaN   \n",
       "8311                     NaN                    NaN         NaN   \n",
       "8310  桂安牌手提式干粉灭火器1 开隆牌消防员灭火服  MFTZ/ABC 4 、ZFMH-KL B      2165.0   \n",
       "8309                消防员灭火防护服             ZFMH-KTZ A        15.0   \n",
       "...                      ...                    ...         ...   \n",
       "4                        NaN                    NaN         NaN   \n",
       "3                        NaN                    NaN         NaN   \n",
       "2                        绯樱球                      包      1999.0   \n",
       "1                        马尾草                      柱       888.0   \n",
       "0                       绝云椒椒                      个      7777.0   \n",
       "\n",
       "      tender_complete_ip  mac_address  hard_disk_seq  status  \\\n",
       "8313                 NaN          NaN            NaN       1   \n",
       "8312                 NaN          NaN            NaN       1   \n",
       "8311                 NaN          NaN            NaN       1   \n",
       "8310                 NaN          NaN            NaN       1   \n",
       "8309                 NaN          NaN            NaN       1   \n",
       "...                  ...          ...            ...     ...   \n",
       "4                    NaN          NaN            NaN       1   \n",
       "3                    NaN          NaN            NaN       1   \n",
       "2                    NaN          NaN            NaN       1   \n",
       "1                    NaN          NaN            NaN       1   \n",
       "0                    NaN          NaN            NaN       1   \n",
       "\n",
       "             create_time  \n",
       "8313  18/8/2023 09:36:35  \n",
       "8312  18/8/2023 09:36:05  \n",
       "8311  18/8/2023 09:35:58  \n",
       "8310  10/8/2023 09:43:18  \n",
       "8309  10/8/2023 09:35:34  \n",
       "...                  ...  \n",
       "4     15/8/2021 12:46:19  \n",
       "3     15/8/2021 11:33:04  \n",
       "2     12/8/2021 16:23:51  \n",
       "1     12/8/2021 16:23:11  \n",
       "0     12/8/2021 16:22:19  \n",
       "\n",
       "[8314 rows x 13 columns]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 索引排序\n",
    "csvData.sort_index(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "a3a1d29c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>project_id</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bidder</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "      <th>tender_complete_ip</th>\n",
       "      <th>mac_address</th>\n",
       "      <th>hard_disk_seq</th>\n",
       "      <th>status</th>\n",
       "      <th>create_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7385</th>\n",
       "      <td>0197DF5AF59D4BAEB074B2789B5287C9</td>\n",
       "      <td>货物</td>\n",
       "      <td>测试公司</td>\n",
       "      <td>5.453412e+09</td>\n",
       "      <td>4543</td>\n",
       "      <td>53453</td>\n",
       "      <td>1234</td>\n",
       "      <td>423.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/5/2023 18:31:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4955</th>\n",
       "      <td>72F1089335464707912C80EBB7D16A5E</td>\n",
       "      <td>货物</td>\n",
       "      <td>中科可控信息产业有限公司</td>\n",
       "      <td>3.995312e+08</td>\n",
       "      <td>180</td>\n",
       "      <td>中科可控</td>\n",
       "      <td>CX55 G40 LP</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4956</th>\n",
       "      <td>72F1089335464707912C80EBB7D16A5E</td>\n",
       "      <td>货物</td>\n",
       "      <td>中国移动通信集团广东有限公司</td>\n",
       "      <td>3.995200e+08</td>\n",
       "      <td>按招标文件要求</td>\n",
       "      <td>高性能通用计算结点（计算处理分系统）</td>\n",
       "      <td>SW26010</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4958</th>\n",
       "      <td>72F1089335464707912C80EBB7D16A5E</td>\n",
       "      <td>货物</td>\n",
       "      <td>中国人民解放军国防科技大学</td>\n",
       "      <td>3.983800e+08</td>\n",
       "      <td>签订合同后3个月内基础架构设备进场；签订合同后6个月内其余设备进场；签订合同后8个月内完成安...</td>\n",
       "      <td>TH</td>\n",
       "      <td>CN124X86等</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4957</th>\n",
       "      <td>72F1089335464707912C80EBB7D16A5E</td>\n",
       "      <td>货物</td>\n",
       "      <td>烽火通信科技股份有限公司</td>\n",
       "      <td>3.906180e+08</td>\n",
       "      <td>180天</td>\n",
       "      <td>烽火</td>\n",
       "      <td>B8000V6</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>A16710ACCA714113BFF8D500E8020A0C</td>\n",
       "      <td>工程</td>\n",
       "      <td>测试测试公司</td>\n",
       "      <td>1.000000e-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>26/9/2021 17:06:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>84A5F9101A10437F83EA75F3F9CCABF0</td>\n",
       "      <td>工程</td>\n",
       "      <td>测试测试公司</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>27/9/2021 10:24:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>F017CFBC19E54C8598739CF3BF1E46E5</td>\n",
       "      <td>工程</td>\n",
       "      <td>测试供应商4</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>29/9/2021 11:34:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7809</th>\n",
       "      <td>F264A74A44AB4C1082BC722D1D8973D4</td>\n",
       "      <td>服务</td>\n",
       "      <td>广州菲达建筑咨询有限公司</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>按招标文件要求</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>21/6/2023 09:31:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>24C7ADEC02514CDF9D8A8461928413C8</td>\n",
       "      <td>货物</td>\n",
       "      <td>思腾合力（天津）科技有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>思腾合力</td>\n",
       "      <td>型号：IW4221-8Gs  规格：2*6348/16*64G/2*960G/3.84T/8...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>24/1/2022 09:06:19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8314 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            project_id purchase_project_type_mean  \\\n",
       "7385  0197DF5AF59D4BAEB074B2789B5287C9                         货物   \n",
       "4955  72F1089335464707912C80EBB7D16A5E                         货物   \n",
       "4956  72F1089335464707912C80EBB7D16A5E                         货物   \n",
       "4958  72F1089335464707912C80EBB7D16A5E                         货物   \n",
       "4957  72F1089335464707912C80EBB7D16A5E                         货物   \n",
       "...                                ...                        ...   \n",
       "146   A16710ACCA714113BFF8D500E8020A0C                         工程   \n",
       "161   84A5F9101A10437F83EA75F3F9CCABF0                         工程   \n",
       "181   F017CFBC19E54C8598739CF3BF1E46E5                         工程   \n",
       "7809  F264A74A44AB4C1082BC722D1D8973D4                         服务   \n",
       "909   24C7ADEC02514CDF9D8A8461928413C8                         货物   \n",
       "\n",
       "              bidder     bid_price  \\\n",
       "7385            测试公司  5.453412e+09   \n",
       "4955    中科可控信息产业有限公司  3.995312e+08   \n",
       "4956  中国移动通信集团广东有限公司  3.995200e+08   \n",
       "4958   中国人民解放军国防科技大学  3.983800e+08   \n",
       "4957    烽火通信科技股份有限公司  3.906180e+08   \n",
       "...              ...           ...   \n",
       "146           测试测试公司  1.000000e-02   \n",
       "161           测试测试公司  0.000000e+00   \n",
       "181           测试供应商4  0.000000e+00   \n",
       "7809    广州菲达建筑咨询有限公司  0.000000e+00   \n",
       "909   思腾合力（天津）科技有限公司           NaN   \n",
       "\n",
       "                                          delivery_time                name  \\\n",
       "7385                                               4543               53453   \n",
       "4955                                                180                中科可控   \n",
       "4956                                            按招标文件要求  高性能通用计算结点（计算处理分系统）   \n",
       "4958  签订合同后3个月内基础架构设备进场；签订合同后6个月内其余设备进场；签订合同后8个月内完成安...                  TH   \n",
       "4957                                               180天                  烽火   \n",
       "...                                                 ...                 ...   \n",
       "146                                                 NaN                 NaN   \n",
       "161                                                 NaN                 NaN   \n",
       "181                                                 NaN                 NaN   \n",
       "7809                                            按招标文件要求                 NaN   \n",
       "909                                                 NaN                思腾合力   \n",
       "\n",
       "                                               bid_spec  bid_amount  \\\n",
       "7385                                               1234       423.0   \n",
       "4955                                        CX55 G40 LP      3000.0   \n",
       "4956                                            SW26010      3000.0   \n",
       "4958                                          CN124X86等      3000.0   \n",
       "4957                                            B8000V6      3000.0   \n",
       "...                                                 ...         ...   \n",
       "146                                                 NaN         NaN   \n",
       "161                                                 NaN         NaN   \n",
       "181                                                 NaN         NaN   \n",
       "7809                                                NaN         NaN   \n",
       "909   型号：IW4221-8Gs  规格：2*6348/16*64G/2*960G/3.84T/8...         1.0   \n",
       "\n",
       "      tender_complete_ip  mac_address  hard_disk_seq  status  \\\n",
       "7385                 NaN          NaN            NaN       1   \n",
       "4955                 NaN          NaN            NaN       1   \n",
       "4956                 NaN          NaN            NaN       1   \n",
       "4958                 NaN          NaN            NaN       1   \n",
       "4957                 NaN          NaN            NaN       1   \n",
       "...                  ...          ...            ...     ...   \n",
       "146                  NaN          NaN            NaN       1   \n",
       "161                  NaN          NaN            NaN       1   \n",
       "181                  NaN          NaN            NaN       1   \n",
       "7809                 NaN          NaN            NaN       1   \n",
       "909                  NaN          NaN            NaN       1   \n",
       "\n",
       "             create_time  \n",
       "7385  20/5/2023 18:31:41  \n",
       "4955  1/12/2022 09:35:27  \n",
       "4956  1/12/2022 09:35:47  \n",
       "4958  1/12/2022 09:35:59  \n",
       "4957  1/12/2022 09:35:49  \n",
       "...                  ...  \n",
       "146   26/9/2021 17:06:05  \n",
       "161   27/9/2021 10:24:36  \n",
       "181   29/9/2021 11:34:59  \n",
       "7809  21/6/2023 09:31:57  \n",
       "909   24/1/2022 09:06:19  \n",
       "\n",
       "[8314 rows x 13 columns]"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csvData.sort_values(by=['bid_price'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "24ba79b2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7809    0.000000e+00\n",
       "161     0.000000e+00\n",
       "181     0.000000e+00\n",
       "146     1.000000e-02\n",
       "53      1.000000e-02\n",
       "            ...     \n",
       "4958    3.983800e+08\n",
       "4956    3.995200e+08\n",
       "4955    3.995312e+08\n",
       "7385    5.453412e+09\n",
       "909              NaN\n",
       "Name: bid_price, Length: 8314, dtype: float64"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 单列排序 \n",
    "csvData['bid_price'].sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "a1d105cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8313    1797950.00\n",
       "8312    1799100.00\n",
       "8311    1798000.00\n",
       "8310     879329.00\n",
       "8309    1202235.00\n",
       "           ...    \n",
       "4        998765.43\n",
       "3        876543.21\n",
       "2        955555.55\n",
       "1        888888.88\n",
       "0        777777.77\n",
       "Name: bid_price, Length: 8314, dtype: float64"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 单列排序 \n",
    "csvData['bid_price'].sort_index(ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0a8a82e3",
   "metadata": {},
   "source": [
    "# 算术运算"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "59006ec2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        787776.77\n",
       "1        898887.88\n",
       "2        965554.55\n",
       "3        886542.21\n",
       "4       1008764.43\n",
       "           ...    \n",
       "8309    1212234.00\n",
       "8310     889328.00\n",
       "8311    1807999.00\n",
       "8312    1809099.00\n",
       "8313    1807949.00\n",
       "Name: bid_price, Length: 8314, dtype: float64"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csvData['bid_price'].add(9999)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "2e1dfe3a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "      <th>tender_complete_ip</th>\n",
       "      <th>mac_address</th>\n",
       "      <th>hard_disk_seq</th>\n",
       "      <th>status</th>\n",
       "      <th>create_time</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>project_id</th>\n",
       "      <th>bidder</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2D063835F923444EBD5A4D05325252B5</th>\n",
       "      <th>测试测试公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.111111e+08</td>\n",
       "      <td>111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/11/2021 09:39:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>測試供應商3</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.300000e+08</td>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/11/2021 09:50:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">A3159B3FE45E4499BABF939981A4367C</th>\n",
       "      <th>测试测试公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.111111e+08</td>\n",
       "      <td>111</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/11/2021 10:00:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>測試供應商3</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>12/11/2021 10:00:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">72F1089335464707912C80EBB7D16A5E</th>\n",
       "      <th>中科可控信息产业有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>3.995312e+08</td>\n",
       "      <td>180</td>\n",
       "      <td>中科可控</td>\n",
       "      <td>CX55 G40 LP</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国移动通信集团广东有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>3.995200e+08</td>\n",
       "      <td>按招标文件要求</td>\n",
       "      <td>高性能通用计算结点（计算处理分系统）</td>\n",
       "      <td>SW26010</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>烽火通信科技股份有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>3.906180e+08</td>\n",
       "      <td>180天</td>\n",
       "      <td>烽火</td>\n",
       "      <td>B8000V6</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国人民解放军国防科技大学</th>\n",
       "      <td>货物</td>\n",
       "      <td>3.983800e+08</td>\n",
       "      <td>签订合同后3个月内基础架构设备进场；签订合同后6个月内其余设备进场；签订合同后8个月内完成安...</td>\n",
       "      <td>TH</td>\n",
       "      <td>CN124X86等</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/12/2022 09:35:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">58D45027BD5442449E482561A76EB752</th>\n",
       "      <th>德阳市久远德重机械制造有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>8.266000e+07</td>\n",
       "      <td>1460</td>\n",
       "      <td>久远德重</td>\n",
       "      <td>定制开发</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2/12/2022 09:34:22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国工程物理研究院总体工程研究所</th>\n",
       "      <td>货物</td>\n",
       "      <td>8.430000e+07</td>\n",
       "      <td>1460</td>\n",
       "      <td>中国工程物理研究院总体工程研究所</td>\n",
       "      <td>GC1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2/12/2022 09:34:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>成都伟特自动化工程有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>8.462700e+07</td>\n",
       "      <td>48个月</td>\n",
       "      <td>伟特</td>\n",
       "      <td>1000gt</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2/12/2022 09:34:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">B3F8DE65ED2E4371B21EBACD87C1F9A7</th>\n",
       "      <th>上海硒跃实业有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>5.600000e+07</td>\n",
       "      <td>365</td>\n",
       "      <td>ASML</td>\n",
       "      <td>PAS5500/550</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>19/12/2022 09:40:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中仪英斯泰克进出口有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>5.488000e+07</td>\n",
       "      <td>365个日历天以内</td>\n",
       "      <td>步进式深紫外光刻机-Nikon/涂胶显影机-TEL/防震台-/</td>\n",
       "      <td>步进式深紫外光刻机-S205C/涂胶显影机-ACT8/防震台-VC-D</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>19/12/2022 09:40:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广东省凯沃半导体科技有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>5.150000e+07</td>\n",
       "      <td>收到发货通知180个日历天以内交货</td>\n",
       "      <td>Canon / TEL</td>\n",
       "      <td>FPA-3000 EX6 / CLEAN TRACK ACT8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>19/12/2022 09:40:22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广东微观科学仪器有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>5.500000e+07</td>\n",
       "      <td>收到发货通知365 个日历天以内交货</td>\n",
       "      <td>ASML/TEL</td>\n",
       "      <td>AT:850C/CLEAN TRACK ACT12</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>19/12/2022 09:40:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>建发（武汉）有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>5.396800e+07</td>\n",
       "      <td>收到发货通知365个日历天以内交货</td>\n",
       "      <td>赛瑾</td>\n",
       "      <td>NSRS205C</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>19/12/2022 09:40:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6BA3A0844895459D84BA51DBC3C0448B</th>\n",
       "      <th>测试机构证书01</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.231231e+08</td>\n",
       "      <td>121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>10/3/2023 19:48:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0197DF5AF59D4BAEB074B2789B5287C9</th>\n",
       "      <th>测试公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>5.453412e+09</td>\n",
       "      <td>4543</td>\n",
       "      <td>53453</td>\n",
       "      <td>1234</td>\n",
       "      <td>423.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/5/2023 18:31:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"12\" valign=\"top\">68DBD214AA3D443F8F9D0E6BFC6D1DE0</th>\n",
       "      <th>保利物业服务股份有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.799664e+08</td>\n",
       "      <td>1095</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:42:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广东宏德科技物业有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.818261e+08</td>\n",
       "      <td>1096</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:42:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>浙江浙大新宇物业集团有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.818266e+08</td>\n",
       "      <td>2023年8月1日至2026年7月31日</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:42:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>珠海市丹田物业管理股份有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.768986e+08</td>\n",
       "      <td>自2023年8月1日至2026年7月31日止</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:42:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新大正物业集团股份有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.787706e+08</td>\n",
       "      <td>自2023年8月1日至2026年7月31日止</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>龙城城市运营服务集团有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.799594e+08</td>\n",
       "      <td>2023年8月1日至2026年7月31日</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航物业管理有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.818233e+08</td>\n",
       "      <td>1096</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广州市泰翔物业管理有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.833004e+08</td>\n",
       "      <td>自2023年8月1日至2026年7月31日止</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>碧桂园生活服务集团股份有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.668590e+08</td>\n",
       "      <td>1095天（三年）</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华发物业服务有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.815397e+08</td>\n",
       "      <td>自2023年8月1日至2026年7月31日止</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳市新东升物业管理有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.818166e+08</td>\n",
       "      <td>2023年8月1日至2026年7月31日</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:43:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京国基伟业物业管理有限公司</th>\n",
       "      <td>服务</td>\n",
       "      <td>1.785687e+08</td>\n",
       "      <td>1096天（自2023年8月1日至2026年7月31日止，具体以合同签订日期为准）</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20/7/2023 09:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96824E1963C04305ABFB75B95C85EDFE</th>\n",
       "      <th>广州粤弘建筑工程有限公司</th>\n",
       "      <td>货物</td>\n",
       "      <td>6.469047e+07</td>\n",
       "      <td>发出中标通知书之日起23个日历天内</td>\n",
       "      <td>10匹变频多联空调系统（一拖二风管式）</td>\n",
       "      <td>型号：TIMS252CSREA；制冷/热量：24.1/26kW；</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/8/2023 09:42:32</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  purchase_project_type_mean  \\\n",
       "project_id                       bidder                                        \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                                   服务   \n",
       "                                 測試供應商3                                   服务   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                                   服务   \n",
       "                                 測試供應商3                                   服务   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司                             货物   \n",
       "                                 中国移动通信集团广东有限公司                           货物   \n",
       "                                 烽火通信科技股份有限公司                             货物   \n",
       "                                 中国人民解放军国防科技大学                            货物   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司                          货物   \n",
       "                                 中国工程物理研究院总体工程研究所                         货物   \n",
       "                                 成都伟特自动化工程有限公司                            货物   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司                               货物   \n",
       "                                 中仪英斯泰克进出口有限公司                            货物   \n",
       "                                 广东省凯沃半导体科技有限公司                           货物   \n",
       "                                 广东微观科学仪器有限公司                             货物   \n",
       "                                 建发（武汉）有限公司                               货物   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                                 服务   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                                     货物   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司                             服务   \n",
       "                                 广东宏德科技物业有限公司                             服务   \n",
       "                                 浙江浙大新宇物业集团有限公司                           服务   \n",
       "                                 珠海市丹田物业管理股份有限公司                          服务   \n",
       "                                 新大正物业集团股份有限公司                            服务   \n",
       "                                 龙城城市运营服务集团有限公司                           服务   \n",
       "                                 中航物业管理有限公司                               服务   \n",
       "                                 广州市泰翔物业管理有限公司                            服务   \n",
       "                                 碧桂园生活服务集团股份有限公司                          服务   \n",
       "                                 华发物业服务有限公司                               服务   \n",
       "                                 深圳市新东升物业管理有限公司                           服务   \n",
       "                                 北京国基伟业物业管理有限公司                           服务   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司                             货物   \n",
       "\n",
       "                                                      bid_price  \\\n",
       "project_id                       bidder                           \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司            1.111111e+08   \n",
       "                                 測試供應商3            1.300000e+08   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司            1.111111e+08   \n",
       "                                 測試供應商3            1.000000e+08   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司      3.995312e+08   \n",
       "                                 中国移动通信集团广东有限公司    3.995200e+08   \n",
       "                                 烽火通信科技股份有限公司      3.906180e+08   \n",
       "                                 中国人民解放军国防科技大学     3.983800e+08   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司   8.266000e+07   \n",
       "                                 中国工程物理研究院总体工程研究所  8.430000e+07   \n",
       "                                 成都伟特自动化工程有限公司     8.462700e+07   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司        5.600000e+07   \n",
       "                                 中仪英斯泰克进出口有限公司     5.488000e+07   \n",
       "                                 广东省凯沃半导体科技有限公司    5.150000e+07   \n",
       "                                 广东微观科学仪器有限公司      5.500000e+07   \n",
       "                                 建发（武汉）有限公司        5.396800e+07   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01          1.231231e+08   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司              5.453412e+09   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司      1.799664e+08   \n",
       "                                 广东宏德科技物业有限公司      1.818261e+08   \n",
       "                                 浙江浙大新宇物业集团有限公司    1.818266e+08   \n",
       "                                 珠海市丹田物业管理股份有限公司   1.768986e+08   \n",
       "                                 新大正物业集团股份有限公司     1.787706e+08   \n",
       "                                 龙城城市运营服务集团有限公司    1.799594e+08   \n",
       "                                 中航物业管理有限公司        1.818233e+08   \n",
       "                                 广州市泰翔物业管理有限公司     1.833004e+08   \n",
       "                                 碧桂园生活服务集团股份有限公司   1.668590e+08   \n",
       "                                 华发物业服务有限公司        1.815397e+08   \n",
       "                                 深圳市新东升物业管理有限公司    1.818166e+08   \n",
       "                                 北京国基伟业物业管理有限公司    1.785687e+08   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司      6.469047e+07   \n",
       "\n",
       "                                                                                       delivery_time  \\\n",
       "project_id                       bidder                                                                \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                                                          111   \n",
       "                                 測試供應商3                                                          365   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                                                          111   \n",
       "                                 測試供應商3                                                          365   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司                                                    180   \n",
       "                                 中国移动通信集团广东有限公司                                              按招标文件要求   \n",
       "                                 烽火通信科技股份有限公司                                                   180天   \n",
       "                                 中国人民解放军国防科技大学     签订合同后3个月内基础架构设备进场；签订合同后6个月内其余设备进场；签订合同后8个月内完成安...   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司                                                1460   \n",
       "                                 中国工程物理研究院总体工程研究所                                               1460   \n",
       "                                 成都伟特自动化工程有限公司                                                  48个月   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司                                                      365   \n",
       "                                 中仪英斯泰克进出口有限公司                                             365个日历天以内   \n",
       "                                 广东省凯沃半导体科技有限公司                                    收到发货通知180个日历天以内交货   \n",
       "                                 广东微观科学仪器有限公司                                     收到发货通知365 个日历天以内交货   \n",
       "                                 建发（武汉）有限公司                                        收到发货通知365个日历天以内交货   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                                                        121   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                                                           4543   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司                                                   1095   \n",
       "                                 广东宏德科技物业有限公司                                                   1096   \n",
       "                                 浙江浙大新宇物业集团有限公司                                 2023年8月1日至2026年7月31日   \n",
       "                                 珠海市丹田物业管理股份有限公司                              自2023年8月1日至2026年7月31日止   \n",
       "                                 新大正物业集团股份有限公司                                自2023年8月1日至2026年7月31日止   \n",
       "                                 龙城城市运营服务集团有限公司                                 2023年8月1日至2026年7月31日   \n",
       "                                 中航物业管理有限公司                                                     1096   \n",
       "                                 广州市泰翔物业管理有限公司                                自2023年8月1日至2026年7月31日止   \n",
       "                                 碧桂园生活服务集团股份有限公司                                           1095天（三年）   \n",
       "                                 华发物业服务有限公司                                   自2023年8月1日至2026年7月31日止   \n",
       "                                 深圳市新东升物业管理有限公司                                 2023年8月1日至2026年7月31日   \n",
       "                                 北京国基伟业物业管理有限公司            1096天（自2023年8月1日至2026年7月31日止，具体以合同签订日期为准）   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司                                      发出中标通知书之日起23个日历天内   \n",
       "\n",
       "                                                                              name  \\\n",
       "project_id                       bidder                                              \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                                        NaN   \n",
       "                                 測試供應商3                                        NaN   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                                        NaN   \n",
       "                                 測試供應商3                                        NaN   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司                                 中科可控   \n",
       "                                 中国移动通信集团广东有限公司                 高性能通用计算结点（计算处理分系统）   \n",
       "                                 烽火通信科技股份有限公司                                   烽火   \n",
       "                                 中国人民解放军国防科技大学                                  TH   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司                              久远德重   \n",
       "                                 中国工程物理研究院总体工程研究所                 中国工程物理研究院总体工程研究所   \n",
       "                                 成都伟特自动化工程有限公司                                  伟特   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司                                   ASML   \n",
       "                                 中仪英斯泰克进出口有限公司     步进式深紫外光刻机-Nikon/涂胶显影机-TEL/防震台-/   \n",
       "                                 广东省凯沃半导体科技有限公司                        Canon / TEL   \n",
       "                                 广东微观科学仪器有限公司                             ASML/TEL   \n",
       "                                 建发（武汉）有限公司                                     赛瑾   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                                      NaN   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                                        53453   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司                                  NaN   \n",
       "                                 广东宏德科技物业有限公司                                  NaN   \n",
       "                                 浙江浙大新宇物业集团有限公司                                NaN   \n",
       "                                 珠海市丹田物业管理股份有限公司                               NaN   \n",
       "                                 新大正物业集团股份有限公司                                 NaN   \n",
       "                                 龙城城市运营服务集团有限公司                                NaN   \n",
       "                                 中航物业管理有限公司                                    NaN   \n",
       "                                 广州市泰翔物业管理有限公司                                 NaN   \n",
       "                                 碧桂园生活服务集团股份有限公司                               NaN   \n",
       "                                 华发物业服务有限公司                                    NaN   \n",
       "                                 深圳市新东升物业管理有限公司                                NaN   \n",
       "                                 北京国基伟业物业管理有限公司                                NaN   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司                  10匹变频多联空调系统（一拖二风管式）   \n",
       "\n",
       "                                                                              bid_spec  \\\n",
       "project_id                       bidder                                                  \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                                            NaN   \n",
       "                                 測試供應商3                                            NaN   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                                            NaN   \n",
       "                                 測試供應商3                                            NaN   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司                              CX55 G40 LP   \n",
       "                                 中国移动通信集团广东有限公司                                SW26010   \n",
       "                                 烽火通信科技股份有限公司                                  B8000V6   \n",
       "                                 中国人民解放军国防科技大学                               CN124X86等   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司                                  定制开发   \n",
       "                                 中国工程物理研究院总体工程研究所                               GC1000   \n",
       "                                 成都伟特自动化工程有限公司                                  1000gt   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司                                PAS5500/550   \n",
       "                                 中仪英斯泰克进出口有限公司     步进式深紫外光刻机-S205C/涂胶显影机-ACT8/防震台-VC-D   \n",
       "                                 广东省凯沃半导体科技有限公司        FPA-3000 EX6 / CLEAN TRACK ACT8   \n",
       "                                 广东微观科学仪器有限公司                AT:850C/CLEAN TRACK ACT12   \n",
       "                                 建发（武汉）有限公司                                   NSRS205C   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                                          NaN   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                                             1234   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司                                      NaN   \n",
       "                                 广东宏德科技物业有限公司                                      NaN   \n",
       "                                 浙江浙大新宇物业集团有限公司                                    NaN   \n",
       "                                 珠海市丹田物业管理股份有限公司                                   NaN   \n",
       "                                 新大正物业集团股份有限公司                                     NaN   \n",
       "                                 龙城城市运营服务集团有限公司                                    NaN   \n",
       "                                 中航物业管理有限公司                                        NaN   \n",
       "                                 广州市泰翔物业管理有限公司                                     NaN   \n",
       "                                 碧桂园生活服务集团股份有限公司                                   NaN   \n",
       "                                 华发物业服务有限公司                                        NaN   \n",
       "                                 深圳市新东升物业管理有限公司                                    NaN   \n",
       "                                 北京国基伟业物业管理有限公司                                    NaN   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司         型号：TIMS252CSREA；制冷/热量：24.1/26kW；   \n",
       "\n",
       "                                                   bid_amount  \\\n",
       "project_id                       bidder                         \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                   NaN   \n",
       "                                 測試供應商3                   NaN   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                   NaN   \n",
       "                                 測試供應商3                   NaN   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司          3000.0   \n",
       "                                 中国移动通信集团广东有限公司        3000.0   \n",
       "                                 烽火通信科技股份有限公司          3000.0   \n",
       "                                 中国人民解放军国防科技大学         3000.0   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司          1.0   \n",
       "                                 中国工程物理研究院总体工程研究所         1.0   \n",
       "                                 成都伟特自动化工程有限公司            1.0   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司               1.0   \n",
       "                                 中仪英斯泰克进出口有限公司            1.0   \n",
       "                                 广东省凯沃半导体科技有限公司           2.0   \n",
       "                                 广东微观科学仪器有限公司             2.0   \n",
       "                                 建发（武汉）有限公司               1.0   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                 NaN   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                   423.0   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司             NaN   \n",
       "                                 广东宏德科技物业有限公司             NaN   \n",
       "                                 浙江浙大新宇物业集团有限公司           NaN   \n",
       "                                 珠海市丹田物业管理股份有限公司          NaN   \n",
       "                                 新大正物业集团股份有限公司            NaN   \n",
       "                                 龙城城市运营服务集团有限公司           NaN   \n",
       "                                 中航物业管理有限公司               NaN   \n",
       "                                 广州市泰翔物业管理有限公司            NaN   \n",
       "                                 碧桂园生活服务集团股份有限公司          NaN   \n",
       "                                 华发物业服务有限公司               NaN   \n",
       "                                 深圳市新东升物业管理有限公司           NaN   \n",
       "                                 北京国基伟业物业管理有限公司           NaN   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司            24.0   \n",
       "\n",
       "                                                   tender_complete_ip  \\\n",
       "project_id                       bidder                                 \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                           NaN   \n",
       "                                 測試供應商3                           NaN   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                           NaN   \n",
       "                                 測試供應商3                           NaN   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司                     NaN   \n",
       "                                 中国移动通信集团广东有限公司                   NaN   \n",
       "                                 烽火通信科技股份有限公司                     NaN   \n",
       "                                 中国人民解放军国防科技大学                    NaN   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司                  NaN   \n",
       "                                 中国工程物理研究院总体工程研究所                 NaN   \n",
       "                                 成都伟特自动化工程有限公司                    NaN   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司                       NaN   \n",
       "                                 中仪英斯泰克进出口有限公司                    NaN   \n",
       "                                 广东省凯沃半导体科技有限公司                   NaN   \n",
       "                                 广东微观科学仪器有限公司                     NaN   \n",
       "                                 建发（武汉）有限公司                       NaN   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                         NaN   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                             NaN   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司                     NaN   \n",
       "                                 广东宏德科技物业有限公司                     NaN   \n",
       "                                 浙江浙大新宇物业集团有限公司                   NaN   \n",
       "                                 珠海市丹田物业管理股份有限公司                  NaN   \n",
       "                                 新大正物业集团股份有限公司                    NaN   \n",
       "                                 龙城城市运营服务集团有限公司                   NaN   \n",
       "                                 中航物业管理有限公司                       NaN   \n",
       "                                 广州市泰翔物业管理有限公司                    NaN   \n",
       "                                 碧桂园生活服务集团股份有限公司                  NaN   \n",
       "                                 华发物业服务有限公司                       NaN   \n",
       "                                 深圳市新东升物业管理有限公司                   NaN   \n",
       "                                 北京国基伟业物业管理有限公司                   NaN   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司                     NaN   \n",
       "\n",
       "                                                   mac_address  hard_disk_seq  \\\n",
       "project_id                       bidder                                         \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                    NaN            NaN   \n",
       "                                 測試供應商3                    NaN            NaN   \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                    NaN            NaN   \n",
       "                                 測試供應商3                    NaN            NaN   \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司              NaN            NaN   \n",
       "                                 中国移动通信集团广东有限公司            NaN            NaN   \n",
       "                                 烽火通信科技股份有限公司              NaN            NaN   \n",
       "                                 中国人民解放军国防科技大学             NaN            NaN   \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司           NaN            NaN   \n",
       "                                 中国工程物理研究院总体工程研究所          NaN            NaN   \n",
       "                                 成都伟特自动化工程有限公司             NaN            NaN   \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司                NaN            NaN   \n",
       "                                 中仪英斯泰克进出口有限公司             NaN            NaN   \n",
       "                                 广东省凯沃半导体科技有限公司            NaN            NaN   \n",
       "                                 广东微观科学仪器有限公司              NaN            NaN   \n",
       "                                 建发（武汉）有限公司                NaN            NaN   \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01                  NaN            NaN   \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                      NaN            NaN   \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司              NaN            NaN   \n",
       "                                 广东宏德科技物业有限公司              NaN            NaN   \n",
       "                                 浙江浙大新宇物业集团有限公司            NaN            NaN   \n",
       "                                 珠海市丹田物业管理股份有限公司           NaN            NaN   \n",
       "                                 新大正物业集团股份有限公司             NaN            NaN   \n",
       "                                 龙城城市运营服务集团有限公司            NaN            NaN   \n",
       "                                 中航物业管理有限公司                NaN            NaN   \n",
       "                                 广州市泰翔物业管理有限公司             NaN            NaN   \n",
       "                                 碧桂园生活服务集团股份有限公司           NaN            NaN   \n",
       "                                 华发物业服务有限公司                NaN            NaN   \n",
       "                                 深圳市新东升物业管理有限公司            NaN            NaN   \n",
       "                                 北京国基伟业物业管理有限公司            NaN            NaN   \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司              NaN            NaN   \n",
       "\n",
       "                                                   status          create_time  \n",
       "project_id                       bidder                                         \n",
       "2D063835F923444EBD5A4D05325252B5 测试测试公司                 1  12/11/2021 09:39:44  \n",
       "                                 測試供應商3                 1  12/11/2021 09:50:42  \n",
       "A3159B3FE45E4499BABF939981A4367C 测试测试公司                 1  12/11/2021 10:00:47  \n",
       "                                 測試供應商3                 1  12/11/2021 10:00:50  \n",
       "72F1089335464707912C80EBB7D16A5E 中科可控信息产业有限公司           1   1/12/2022 09:35:27  \n",
       "                                 中国移动通信集团广东有限公司         1   1/12/2022 09:35:47  \n",
       "                                 烽火通信科技股份有限公司           1   1/12/2022 09:35:49  \n",
       "                                 中国人民解放军国防科技大学          1   1/12/2022 09:35:59  \n",
       "58D45027BD5442449E482561A76EB752 德阳市久远德重机械制造有限公司        1   2/12/2022 09:34:22  \n",
       "                                 中国工程物理研究院总体工程研究所       1   2/12/2022 09:34:23  \n",
       "                                 成都伟特自动化工程有限公司          1   2/12/2022 09:34:39  \n",
       "B3F8DE65ED2E4371B21EBACD87C1F9A7 上海硒跃实业有限公司             1  19/12/2022 09:40:12  \n",
       "                                 中仪英斯泰克进出口有限公司          1  19/12/2022 09:40:16  \n",
       "                                 广东省凯沃半导体科技有限公司         1  19/12/2022 09:40:22  \n",
       "                                 广东微观科学仪器有限公司           1  19/12/2022 09:40:32  \n",
       "                                 建发（武汉）有限公司             1  19/12/2022 09:40:35  \n",
       "6BA3A0844895459D84BA51DBC3C0448B 测试机构证书01               1   10/3/2023 19:48:32  \n",
       "0197DF5AF59D4BAEB074B2789B5287C9 测试公司                   1   20/5/2023 18:31:41  \n",
       "68DBD214AA3D443F8F9D0E6BFC6D1DE0 保利物业服务股份有限公司           1   20/7/2023 09:42:54  \n",
       "                                 广东宏德科技物业有限公司           1   20/7/2023 09:42:55  \n",
       "                                 浙江浙大新宇物业集团有限公司         1   20/7/2023 09:42:58  \n",
       "                                 珠海市丹田物业管理股份有限公司        1   20/7/2023 09:42:59  \n",
       "                                 新大正物业集团股份有限公司          1   20/7/2023 09:43:01  \n",
       "                                 龙城城市运营服务集团有限公司         1   20/7/2023 09:43:02  \n",
       "                                 中航物业管理有限公司             1   20/7/2023 09:43:03  \n",
       "                                 广州市泰翔物业管理有限公司          1   20/7/2023 09:43:06  \n",
       "                                 碧桂园生活服务集团股份有限公司        1   20/7/2023 09:43:08  \n",
       "                                 华发物业服务有限公司             1   20/7/2023 09:43:14  \n",
       "                                 深圳市新东升物业管理有限公司         1   20/7/2023 09:43:43  \n",
       "                                 北京国基伟业物业管理有限公司         1   20/7/2023 09:45:54  \n",
       "96824E1963C04305ABFB75B95C85EDFE 广州粤弘建筑工程有限公司           1    1/8/2023 09:42:32  "
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#条件查询\n",
    "# csvData.query('bid_price>10000000 & bid_price<50000000').set_index(['project_id','bidder'])\n",
    "csvData.query('bid_price>50000000').set_index(['project_id','bidder'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "id": "5041f0c4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>project_id</th>\n",
       "      <th>purchase_project_type_mean</th>\n",
       "      <th>bidder</th>\n",
       "      <th>bid_price</th>\n",
       "      <th>delivery_time</th>\n",
       "      <th>name</th>\n",
       "      <th>bid_spec</th>\n",
       "      <th>bid_amount</th>\n",
       "      <th>tender_complete_ip</th>\n",
       "      <th>mac_address</th>\n",
       "      <th>hard_disk_seq</th>\n",
       "      <th>status</th>\n",
       "      <th>create_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8272</th>\n",
       "      <td>96824E1963C04305ABFB75B95C85EDFE</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州粤弘建筑工程有限公司</td>\n",
       "      <td>1993981.64</td>\n",
       "      <td>发出中标通知书之日起23个日历天内</td>\n",
       "      <td>14HP冷暖变频多联式空调室外机</td>\n",
       "      <td>TIMS400CSRYA；制冷量45kW/制热量45kW</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/8/2023 09:35:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8282</th>\n",
       "      <td>96824E1963C04305ABFB75B95C85EDFE</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州粤弘建筑工程有限公司</td>\n",
       "      <td>64690468.00</td>\n",
       "      <td>发出中标通知书之日起23个日历天内</td>\n",
       "      <td>10匹变频多联空调系统（一拖二风管式）</td>\n",
       "      <td>型号：TIMS252CSREA；制冷/热量：24.1/26kW；</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/8/2023 09:42:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8291</th>\n",
       "      <td>96824E1963C04305ABFB75B95C85EDFE</td>\n",
       "      <td>货物</td>\n",
       "      <td>广州粤弘建筑工程有限公司</td>\n",
       "      <td>881355.20</td>\n",
       "      <td>发出中标通知书之日起23个日历天内</td>\n",
       "      <td>72匹变频多联空调系统（一拖二十二天花式）</td>\n",
       "      <td>TIMS720DXA(24+24+24)；室外机总制冷/热量：205.5/225kW；</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1/8/2023 09:44:48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            project_id purchase_project_type_mean  \\\n",
       "8272  96824E1963C04305ABFB75B95C85EDFE                         货物   \n",
       "8282  96824E1963C04305ABFB75B95C85EDFE                         货物   \n",
       "8291  96824E1963C04305ABFB75B95C85EDFE                         货物   \n",
       "\n",
       "            bidder    bid_price      delivery_time                   name  \\\n",
       "8272  广州粤弘建筑工程有限公司   1993981.64  发出中标通知书之日起23个日历天内       14HP冷暖变频多联式空调室外机   \n",
       "8282  广州粤弘建筑工程有限公司  64690468.00  发出中标通知书之日起23个日历天内    10匹变频多联空调系统（一拖二风管式）   \n",
       "8291  广州粤弘建筑工程有限公司    881355.20  发出中标通知书之日起23个日历天内  72匹变频多联空调系统（一拖二十二天花式）   \n",
       "\n",
       "                                         bid_spec  bid_amount  \\\n",
       "8272                 TIMS400CSRYA；制冷量45kW/制热量45kW         8.0   \n",
       "8282             型号：TIMS252CSREA；制冷/热量：24.1/26kW；        24.0   \n",
       "8291  TIMS720DXA(24+24+24)；室外机总制冷/热量：205.5/225kW；         1.0   \n",
       "\n",
       "      tender_complete_ip  mac_address  hard_disk_seq  status  \\\n",
       "8272                 NaN          NaN            NaN       1   \n",
       "8282                 NaN          NaN            NaN       1   \n",
       "8291                 NaN          NaN            NaN       1   \n",
       "\n",
       "            create_time  \n",
       "8272  1/8/2023 09:35:12  \n",
       "8282  1/8/2023 09:42:32  \n",
       "8291  1/8/2023 09:44:48  "
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csvData[csvData['bidder'].isin(['广州粤弘建筑工程有限公司','广州碧鼎信息科技有限公司'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fe442e05",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
